﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace AccesoDatos.Modulos.ClasesAccesoDatos
{
   public class AD_REP_TOT_PROY_BY_CLIENTE
    {

       public DataTable SEL_TOT_PROY_BY_CLIENTE(SqlCommand comando, int CLI_CODCLIENTE)
       {
           try
           {
               string sp = "SP_SEL_TOT_PROY_BY_CLIENTE";

               comando.CommandType = CommandType.StoredProcedure;
               comando.CommandText = sp;
               comando.Parameters.Clear();

               comando.Parameters.Add(new SqlParameter("@CLI_CODCLIENTE", SqlDbType.Int));


               comando.Parameters[0].Value = CLI_CODCLIENTE;


               IDbDataAdapter da = new SqlDataAdapter((SqlCommand)comando);
               DataSet ds = new DataSet();
               da.Fill(ds);

               return ds.Tables[0];



           }
           catch (Exception exc)
           {
               throw exc;
           }
       }


       
       


    }
}
